Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

User Role
1) A GRANT statement that grants permission to execute a stored procedure
2) A GRANT statement that grants permission to run action queries
3) A GRANT statement that grants SELECT permission to specific columns
4) A REVOKE statement that revokes all permissions for the Bankers table
5) A REVOKE statement that revokes permission to create databases and tables
6) A REVOKE statement that revokes SELECT permission
7) A REVOKE statement that revokes the DELETE permission
8) All permissions applicable to the specified securable will be granted to the specified principal
9) Altering a SQL Server Login
10) Altering a Windows Login
11) Change the default schema for user Fred
12) Check user id with user_id() function
13) Create a new schema
14) Create a proxy login from the certificate
15) Create a proxy user
16) Create a proxy user and grant access to the schema
17) Create a user and a table, and make the user own the table
18) Create a user and a table, and make the user the owner of the table
19) Creates a new Windows login and then maps that login to a new database user
20) Creating a certificate and an asymmetric key
21) Creating a certificate in the master database
22) Creating a SQL Server Login
23) Creating a Windows Login
24) Creating Database Users with schema
25) DENY Statement
26) Denying SQL Server Access to a Windows User or Group
27) DROP LOGIN
28) Dropping a SQL Login
29) Dropping a Windows Login
30) Example of GRANT EXEC Statement
31) GRANT CREATE FUNCTION TO mary
32) GRANT CREATE TABLE, CREATE PROCEDURE TO peter, paul, mary
33) Granting Permission on a Column in a View
34) Managing Application Roles
35) Managing Fixed Database Role Membership
36) Managing Server Role Members
37) Managing User-Defined Database Roles
38) Modifying a Database User for name
39) Modifying a Database User for the schema
40) Move tables between schemas
41) Reference the schema in a query
42) Removing a Database User from the Database
43) Reporting Fixed Database Roles Information
44) Reporting Fixed Server Role Information
45) REVOKE permissions
46) REVOKE Statement
47) Select CURRENT_USER
48) Select USER
49) Some of the SQL Server fixed server roles
50) The DENY statement is used to explicitly prohibit a user or role members from performing a specific action on an object
51) The use of the CONTROL permission
52) The use of the CREATE SCHEMA statement
53) The use of the SELECT permission within the GRANT statement
54) The use of the UPDATE permission within the GRANT statement
55) The use of the VIEW DEFINITION permission
56) The use of the WITH GRANT OPTION clause of the GRANT statement
57) To grant permission is to give or allow permission to perform a type of operation on an object
58) USER_NAME Function returns the name of user logged into the database The syntax for the USER_NAME function is as follows
59) Viewing SQL Server Logins
60) Viewing Windows Logins